# import pandas as pd
#
# from datareport.api import ImageUtil
# from datareport.api.annotation.Font import Font
# from datareport.api.enum.ColorEnum import ColorEnum
# from datareport.impl.paragraph.base.BaseParagraph import BaseParagraph
# from datareport.api.annotation.Style import style
# from datareport.api.enum.ParagraphStyleEnum import ParagraphStyleEnum
#
#
# @style()
# class YueMo_GongShiQingKuang_24(BaseParagraph):
#     """
#     月末公示
#     """
#
#     def __init__(self):
#         super().__init__()
#         self.text = '''2、月末公示: 从组织生活开展情况来看，各二级党组织月末公示存在不及时的情况，如年中多次抽查，仅个别党组织进行党务公开网公开，多次工作提醒后公示率仍旧不高。截至2023年1月14日，机械与汽车工程学院党委等个二级党组织所属党支部组织生活在党务公开网进行公示占比44.4%。'''
#         self.fonts=[
#             Font(text=self.text,color=ColorEnum.RED.value)
#         ]
#         self.sort = 15
#         self.section = 4
#
#     def plot(self, df, plt):
#         pass
#
#     def getData(self, result):
#         pass
#
#     def start(self, conn, year, plt):
#         df=pd.read_sql('''
#         select left(partyOrgName,2) '党委',round(100*avg(status),1) '公示情况' from(
#         select case when completeStatus='通过' then 1 else 0 end status,
#         partyOrgName from t_meetinginfo)new group by partyOrgName
#         ''',con=conn)
#         self.image=ImageUtil.plot(df,ylable='公示比例（%）')
#
